Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerAccountID (FK)(PK) | A unique identifier for a customer account. | ID_CTAC | Identity | integer | |
CreditLimitAmount | The maximum balance (principal) that may be carried by a customer in this charge account. | MO_CR_LM_AMT | Money | decimal(16,5) | |
AnnualInterestRatePercent | The annual rate used to calculate interest on the outstanding balance in this charge account. Most credit cards specify a daily percentage rate which is the annual rate divided by 365 (or a value close to that). | PE_ANN_INTRST_RT | Percent | decimal(7,4) | |
PenaltyAnnualInterestRatePercent | The annual interest percent charged for balances carred beyond the payment due date. | PE_PNTY_ANN_INTRST_RT | Percent | decimal(7,4) | |
PenaltyFeeAmount | A flat fee assessed for late or missed payments. | MO_PNTY_FE_AMT | Money | decimal(16,5) | |
GracePeriodDayCount | A number of days a creditor may choose to defer penalties and penalty interest rate. The grace period extends the payment due date and enables a customer to avoid incurring penalty fees and interest. | DI_GRC_PRD_DY_CNT | QuantityDayCount | decimal(3,0) | |
BillingCycleMonthDay | The month and day of the month that a payment must be made against the principal and interest balance in the account. | DC_BLLNG_CYCL_MNTH_DY | DateFiscalDay | char(1) | |
MinimumInterestChargeAmount | A mininmum monteary amount charged for interest. For example accrued interest of $.59 would result in a charge of $1.00. In this scenario the $1.00 is th eMinimumInterestChargedAmount | MO_MNM_INTRST_CHG_AMT | Money | decimal(16,5) | |
MinimumPaymentAmount | The minimum payment amount that must be paid on or before the billing cycle ending date in order to avoid penalty and interest. | MO_MNM_PYM_AMT | Money | decimal(16,5) | |